package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_member_entrepreneur;

//DAO
public interface T_member_entrepreneurMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_MEMBER_ENTREPRENEUR  WHERE ID = #{ID}")
	public ApiT_member_entrepreneur findT_member_entrepreneurById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_member_entrepreneur")
	public List<ApiT_member_entrepreneur> findT_member_entrepreneurs();

	// 添加
	public int insertT_member_entrepreneur(ApiT_member_entrepreneur t_member_entrepreneur);

	// 修改
	@Update("UPDATE T_MEMBER_ENTREPRENEUR SET USER_ID = #{user_id,jdbcType=INTEGER}, USER_NAME = #{user_name,jdbcType=VARCHAR}, USER_MOBILE = #{user_mobile,jdbcType=VARCHAR}, CORP_FNAME = #{corp_fname,jdbcType=VARCHAR}, CORP_SNAME = #{corp_sname,jdbcType=VARCHAR}, LOGO_IMG = #{logo_img,jdbcType=VARCHAR}, CORP_BRIEF = #{corp_brief,jdbcType=VARCHAR}, CORP_TAX = #{corp_tax,jdbcType=VARCHAR}, LICENCE_IMG = #{licence_img,jdbcType=VARCHAR}, SCOPE = #{scope,jdbcType=VARCHAR}, ADDRESS = #{address,jdbcType=VARCHAR}, LEGAL_PERSON = #{legal_person,jdbcType=VARCHAR}, IDENTIFICATION = #{identification,jdbcType=VARCHAR}, LEGAL_MOBILE = #{legal_mobile,jdbcType=VARCHAR}, IDENTIFICATION_FRONT = #{identification_front,jdbcType=VARCHAR},"
			+ " IDENTIFICATION_BACK = #{identification_back,jdbcType=VARCHAR}, PROXY_IMG = #{proxy_img,jdbcType=VARCHAR}, CORP_PICTURE = #{corp_picture,jdbcType=VARCHAR}, STATUS = #{status,jdbcType=INTEGER}, UPDATE_TIME =  #{update_time,jdbcType=VARCHAR}, REASON = #{reason,jdbcType=VARCHAR}, APPLY_TIME = #{apply_time,jdbcType=VARCHAR}, APPLY_UID = #{apply_uid,jdbcType=INTEGER}, EXT1 = #{ext1,jdbcType=VARCHAR}, EXT2 = #{ext2,jdbcType=VARCHAR}, EXT3 = #{ext3,jdbcType=VARCHAR}, EXT4 = #{ext4,jdbcType=VARCHAR}, EXT5 = #{ext5,jdbcType=VARCHAR} ,referee_name =#{referee_name,jdbcType=VARCHAR},referee_id=#{referee_id,jdbcType=VARCHAR},corp_mobile=#{corp_mobile,jdbcType=VARCHAR},"
			+ " trademark_img=#{trademark_img,jdbcType=VARCHAR},industry_category=#{industry_category,jdbcType=VARCHAR},corp_web=#{corp_web,jdbcType=VARCHAR},corp_id=#{corp_id,jdbcType=VARCHAR},customer_service_number = #{customer_service_number,jdbcType=VARCHAR},corp_name=#{corp_name,jdbcType=VARCHAR},staff_size=#{staff_size,jdbcType=VARCHAR}, referee_type = #{referee_type,jdbcType=INTEGER}, referee_deadline = #{referee_deadline,jdbcType=VARCHAR}, bonus_ratio = #{bonus_ratio,jdbcType=INTEGER} WHERE ID = #{id}")
	public int updateT_member_entrepreneur(ApiT_member_entrepreneur t_member_entrepreneur);

	// 删除
	@Delete("DELETE FROM T_MEMBER_ENTREPRENEUR  WHERE ID = #{ID}")
	public int deleteT_member_entrepreneur(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
